##############################################################
## MOD Title: phpBB Sportsuite - Upgrade from 0.2.1 to 0.2.1a
## MOD Author: Creomire < ghughes@creomire.com > (Garry Hughes) http://www.olympus.creomire.com
## MOD Description: These instructions are for upgrades from version 0.2.1 to 0.2.1a only
##
## MOD Version: 0.2.1a (upgrade from 0.2.1)
##
## Installation Level: Easy
## Installation Time: 2 Minutes
##
## Files To Edit: 0
##
## Included Files: 1
##			includes/mods/sportsuite/sportsuite.php
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################
## Author Notes:
## This is ALPHA software. You should only install this software on your board if you are comfortable 
## editing php files and especially your database.
##
##############################################################
## History:
##  (dd-mm-yyyy)
##   20-07-2007 - version 0.2.1a
##	- Minor bug fix
##
##   20-07-2007 - version 0.2.1
##	- Added overall stats to league tables
##	- Removed "confirm fixture" facility (obsolete)
##	- Added retrospective results facility
##	- Added minute options to autoclose configuration
##	- User predictions now only update if they have changed (saves db queries)
##	- Added filter options to fixtures page
##	- Stats and information added to admin welcome page
##	- Various minor bug fixes and tweaks
##
##   17-07-2007 - version 0.2.0
##	- Re-write of the fixture addition system, allowing multiple additions at once
##	- Fixed typos in install file
##
##   15-07-2007 - version 0.1.2
##	- Fixed a bug in team statistics calculation
##	- New team statistics database table added, saving repeat calculations
##	- Fixed bug where leagues without teams where visible to "public"
##	- Fixed small bug with user table (leaderboard)
##	- Added ability to "mass add" teams, as opposed to one at a time
##	- Added autoclose facility for fixtures
##	- Automatic removal of "correct score" details if admin doesn't set correct score fixtures
##		or users haven't managed any correct scores
##	- Fixed bug in sportsbook_fixtures.php where league with no teams causes errors
##	- Added facility to recalculate league statistics
##	- Added reset options
##	- Various minor bug fixes and tweaks
##
##   13-07-2007 - version 0.1.1
##	- Small bug fix with Sportsuite's use of request_var() function
##
##   12-07-2007 - version 0.1.0
##	- Integration with phpbb`s native cache system
##	- Added ability for admin to set a home/away (1-2) fixture
##	- Explanation of league table column abbreviations added.
##
##   09-07-2007 - version 0.0.2
##	- Mod version added to footers
##	- Fixed bug in results.php were outstanding fixtures were causing problems
##	- Added ability to toggle fail points on and off.
##	- Trigger user statistics re-build after points system has been changed in sportsbook config.
##
##   08-07-2007 - version 0.0.1
##	- First Alpha release
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ SQL ]------------------------------------------
#

UPDATE `phpbb_sportsuite_config` SET `config_value` = 'ver. 0.2.1a' WHERE CONVERT( `phpbb_sportsuite_config`.`config_name` USING utf8 ) = 'sportsuite_version';

#
#-----[ COPY ]------------------------------------------
#
copy root/includes/mods/sportsuite/sportsuite.php to includes/mods/sportsuite/sportsuite.php

#
#-----[ EOM ]------------------------------------------
#